All Functions and Procedures

Name Unit Description
BoolAsWord XLSUtils5

 

BytesToHexStr XLSUtils5

 

CharInSet XLSUtils5

 

CmToEmu XLSUtils5

 

CPos XLSUtils5

 

CPos XLSUtils5

 

EmptyGUID XLSUtils5

 

EmuToCm XLSUtils5

 

ExportCSV XLSExportCSV5

This routin will export the content of a worksheet to a text (CSV) file. ˜param XLS The XLSReadWriteII object to export. ˜param SheetIndex Index of the work sheet to export. ˜param QuoteChar Quote character for text strings. ˜param SeparatorChar The character used to separate the cell values (fields) in the file. Common used characters are comma, semicolon and tab. ˜param Options File export options. ˜param Filename The name of the file that the cells shall be exported to.

Fork XLSUtils5

 

Fork XLSUtils5

 

ImportCSV XLSImportCSV5

 

ImportCSV XLSImportCSV5

This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. Correct value for decimal separator is detected automatically. See alse ˜[link ImportCSVAuto] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param SepChar Separator character for the fields (cells) in the source file. ˜param HasQuoteChar Set this to True if strings in the source file are quoted. ˜result The number of cells that where imported.

ImportCSVAuto XLSImportCSV5

This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. The routine will try to detect correct values for separator character, quote character and decimal separator. See alse ˜[link ImportCSV] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜result The number of cells that where imported.

ImportHTMLTable XLSImportHTMLTable5

This routine will import a table <TABLE> tag from a html file into a worksheet. Any existing cells on the worksheet will be overwritten. ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param TableIndex The zero based index of which table (if there is more than one) that shall be imported. If TableIndex is set to -1, all tables will be imported. ˜param SpecialDecode Default set to False. Don't change this. ˜param DecSep Decimal separator character. Default is the Delphi DecimalSeparator global variable value. Change this if numeric values not are imported correct. ˜result True if any cells where imported.

MakeIndent XLSUtils5

 

MakePasswordHash XLSUtils5

 

PasswordFromHash XLSUtils5

 

PixelsPerInchXY XLSUtils5

 

RCPos XLSUtils5

 

RCPos XLSUtils5

 

RGBToTColor XLSUtils5

 

RoundToDecimal XLSUtils5

 

SafeTryStrToFloat XLSUtils5

 

SortDoubleArray XLSUtils5

 

SplitAtChar XLSUtils5

 

StreamIsZIP XLSUtils5

 

StripQuotes XLSUtils5

 

TColorToRGB XLSUtils5

 

TryCurrencyStrToFloat XLSUtils5

 

UnicodeIs8Bit XLSUtils5

 

XLSCalcCRC32 XLSUtils5

 

XLSRoundTo XLSUtils5

 

_XLSReplaceStr XLSUtils5

 


Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48